Which are the different services in SQL Server ? How do you manage them ?
2202
28-Mar-2011
Updated on 18-Sep-2020
Amit Singh
28-Mar-2011DTS: By using DTS, you can build data warehouses and data marts in SQL Server by importing and transferring data from multiple heterogeneous sources interactively or automatically on a regularly scheduled basis.
Analysis Services: Analysis Services provides tools for analyzing the data stored in data warehouses and data marts.
Metadata services: SQL Server Meta Data Services provides a way to store and manage metadata about information systems and applications. This technology serves as a hub for data and component definitions, development and deployment models, reusable software components, and data warehousing descriptions.
Reporting services: used to generate reports from the data in the database